﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsFacturacion" targetNamespace="http://tempuri.org/dsFacturacion.xsd" xmlns:mstns="http://tempuri.org/dsFacturacion.xsd" xmlns="http://tempuri.org/dsFacturacion.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="2" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="ConnectionString1" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ConnectionString1 (MySettings)" ParameterPrefix=":" PropertyReference="ApplicationSettings.lbGlobalcom.My.MySettings.GlobalReference.Default.ConnectionString1" Provider="Oracle.DataAccess.Client" />
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ConnectionString (MySettings)" ParameterPrefix=":" PropertyReference="ApplicationSettings.lbGlobalcom.My.MySettings.GlobalReference.Default.ConnectionString" Provider="System.Data.OracleClient" />
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="ConnectionString6" IsAppSettingsProperty="true" Modifier="Assembly" Name="ConnectionString6 (MySettings)" ParameterPrefix=":" PropertyReference="ApplicationSettings.lbGlobalcom.My.MySettings.GlobalReference.Default.ConnectionString6" Provider="Oracle.DataAccess.Client" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FAC_CANALESTableAdapter" GeneratorDataComponentClassName="FAC_CANALESTableAdapter" Name="FAC_CANALES" UserDataComponentName="FAC_CANALESTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.FAC_CANALES" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "SAMUEL"."FAC_CANALES" WHERE (("IDCANAL" = :Original_IDCANAL) AND ((:IsNull_IDLISTA = 1 AND "IDLISTA" IS NULL) OR ("IDLISTA" = :Original_IDLISTA)) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)) AND ((:IsNull_PORRENTA = 1 AND "PORRENTA" IS NULL) OR ("PORRENTA" = :Original_PORRENTA)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCANAL" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCANAL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDLISTA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDLISTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PORRENTA" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="PORRENTA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_PORRENTA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PORRENTA" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "SAMUEL"."FAC_CANALES" ("IDCANAL", "IDLISTA", "DESCRIPCION", "PORRENTA") VALUES (:IDCANAL, :IDLISTA, :DESCRIPCION, :PORRENTA)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCANAL" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCANAL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDLISTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="PORRENTA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PORRENTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDCANAL, IDLISTA, DESCRIPCION, PORRENTA FROM SAMUEL.FAC_CANALES</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "SAMUEL"."FAC_CANALES" SET "IDCANAL" = :IDCANAL, "IDLISTA" = :IDLISTA, "DESCRIPCION" = :DESCRIPCION, "PORRENTA" = :PORRENTA WHERE (("IDCANAL" = :Original_IDCANAL) AND ((:IsNull_IDLISTA = 1 AND "IDLISTA" IS NULL) OR ("IDLISTA" = :Original_IDLISTA)) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)) AND ((:IsNull_PORRENTA = 1 AND "PORRENTA" IS NULL) OR ("PORRENTA" = :Original_PORRENTA)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCANAL" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCANAL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDLISTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="PORRENTA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PORRENTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCANAL" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCANAL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDLISTA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDLISTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PORRENTA" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="PORRENTA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_PORRENTA" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PORRENTA" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDCANAL" DataSetColumn="IDCANAL" />
              <Mapping SourceColumn="IDLISTA" DataSetColumn="IDLISTA" />
              <Mapping SourceColumn="DESCRIPCION" DataSetColumn="DESCRIPCION" />
              <Mapping SourceColumn="PORRENTA" DataSetColumn="PORRENTA" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.FAC_CANALES" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdCanal" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdCanal" GeneratorSourceName="FillByIdCanal" GetMethodModifier="Public" GetMethodName="GetDataByIdCanal" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdCanal" UserSourceName="FillByIdCanal">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     DESCRIPCION, PORRENTA, IDCANAL, IDLISTA
FROM         FAC_CANALES
WHERE     (IDCANAL = :PIDCANAL)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDCANAL" ColumnName="IDCANAL" DataSourceName="SAMUEL.FAC_CANALES" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PIDCANAL" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCANAL" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FAC_PROMOCIONESTableAdapter" GeneratorDataComponentClassName="FAC_PROMOCIONESTableAdapter" Name="FAC_PROMOCIONES" UserDataComponentName="FAC_PROMOCIONESTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.FAC_PROMOCIONES" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "SAMUEL"."FAC_PROMOCIONES" WHERE (("IDPROMOCION" = :Original_IDPROMOCION) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)) AND ((:IsNull_IDPRODUCTO = 1 AND "IDPRODUCTO" IS NULL) OR ("IDPRODUCTO" = :Original_IDPRODUCTO)) AND ((:IsNull_IDTIPOPRODUCTO = 1 AND "IDTIPOPRODUCTO" IS NULL) OR ("IDTIPOPRODUCTO" = :Original_IDTIPOPRODUCTO)) AND ((:IsNull_CANTIDADCOMPRAR = 1 AND "CANTIDADCOMPRAR" IS NULL) OR ("CANTIDADCOMPRAR" = :Original_CANTIDADCOMPRAR)) AND ((:IsNull_UNIDADESOBSEQUIAR = 1 AND "UNIDADESOBSEQUIAR" IS NULL) OR ("UNIDADESOBSEQUIAR" = :Original_UNIDADESOBSEQUIAR)) AND ((:IsNull_DESDEFECHA = 1 AND "DESDEFECHA" IS NULL) OR ("DESDEFECHA" = :Original_DESDEFECHA)) AND ((:IsNull_HASTAFECHA = 1 AND "HASTAFECHA" IS NULL) OR ("HASTAFECHA" = :Original_HASTAFECHA)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPROMOCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDPROMOCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDPRODUCTO" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDTIPOPRODUCTO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDTIPOPRODUCTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTIPOPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CANTIDADCOMPRAR" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="CANTIDADCOMPRAR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_CANTIDADCOMPRAR" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CANTIDADCOMPRAR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_UNIDADESOBSEQUIAR" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="UNIDADESOBSEQUIAR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_UNIDADESOBSEQUIAR" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="UNIDADESOBSEQUIAR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESDEFECHA" Precision="0" ProviderType="Int32" Scale="0" Size="7" SourceColumn="DESDEFECHA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="Original_DESDEFECHA" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="DESDEFECHA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_HASTAFECHA" Precision="0" ProviderType="Int32" Scale="0" Size="7" SourceColumn="HASTAFECHA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="Original_HASTAFECHA" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="HASTAFECHA" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "SAMUEL"."FAC_PROMOCIONES" ("IDPROMOCION", "DESCRIPCION", "IDPRODUCTO", "IDTIPOPRODUCTO", "CANTIDADCOMPRAR", "UNIDADESOBSEQUIAR", "DESDEFECHA", "HASTAFECHA") VALUES (:IDPROMOCION, :DESCRIPCION, :IDPRODUCTO, :IDTIPOPRODUCTO, :CANTIDADCOMPRAR, :UNIDADESOBSEQUIAR, :DESDEFECHA, :HASTAFECHA)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPROMOCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDPROMOCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTIPOPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="CANTIDADCOMPRAR" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CANTIDADCOMPRAR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="UNIDADESOBSEQUIAR" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="UNIDADESOBSEQUIAR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="DESDEFECHA" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="DESDEFECHA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="HASTAFECHA" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="HASTAFECHA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDPROMOCION, DESCRIPCION, IDPRODUCTO, IDTIPOPRODUCTO, CANTIDADCOMPRAR, UNIDADESOBSEQUIAR, DESDEFECHA, HASTAFECHA FROM SAMUEL.FAC_PROMOCIONES</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "SAMUEL"."FAC_PROMOCIONES" SET "IDPROMOCION" = :IDPROMOCION, "DESCRIPCION" = :DESCRIPCION, "IDPRODUCTO" = :IDPRODUCTO, "IDTIPOPRODUCTO" = :IDTIPOPRODUCTO, "CANTIDADCOMPRAR" = :CANTIDADCOMPRAR, "UNIDADESOBSEQUIAR" = :UNIDADESOBSEQUIAR, "DESDEFECHA" = :DESDEFECHA, "HASTAFECHA" = :HASTAFECHA WHERE (("IDPROMOCION" = :Original_IDPROMOCION) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)) AND ((:IsNull_IDPRODUCTO = 1 AND "IDPRODUCTO" IS NULL) OR ("IDPRODUCTO" = :Original_IDPRODUCTO)) AND ((:IsNull_IDTIPOPRODUCTO = 1 AND "IDTIPOPRODUCTO" IS NULL) OR ("IDTIPOPRODUCTO" = :Original_IDTIPOPRODUCTO)) AND ((:IsNull_CANTIDADCOMPRAR = 1 AND "CANTIDADCOMPRAR" IS NULL) OR ("CANTIDADCOMPRAR" = :Original_CANTIDADCOMPRAR)) AND ((:IsNull_UNIDADESOBSEQUIAR = 1 AND "UNIDADESOBSEQUIAR" IS NULL) OR ("UNIDADESOBSEQUIAR" = :Original_UNIDADESOBSEQUIAR)) AND ((:IsNull_DESDEFECHA = 1 AND "DESDEFECHA" IS NULL) OR ("DESDEFECHA" = :Original_DESDEFECHA)) AND ((:IsNull_HASTAFECHA = 1 AND "HASTAFECHA" IS NULL) OR ("HASTAFECHA" = :Original_HASTAFECHA)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPROMOCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDPROMOCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTIPOPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="CANTIDADCOMPRAR" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CANTIDADCOMPRAR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="UNIDADESOBSEQUIAR" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="UNIDADESOBSEQUIAR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="DESDEFECHA" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="DESDEFECHA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="HASTAFECHA" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="HASTAFECHA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPROMOCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDPROMOCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDPRODUCTO" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDTIPOPRODUCTO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDTIPOPRODUCTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTIPOPRODUCTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOPRODUCTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CANTIDADCOMPRAR" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="CANTIDADCOMPRAR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_CANTIDADCOMPRAR" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CANTIDADCOMPRAR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_UNIDADESOBSEQUIAR" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="UNIDADESOBSEQUIAR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_UNIDADESOBSEQUIAR" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="UNIDADESOBSEQUIAR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESDEFECHA" Precision="0" ProviderType="Int32" Scale="0" Size="7" SourceColumn="DESDEFECHA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="Original_DESDEFECHA" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="DESDEFECHA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_HASTAFECHA" Precision="0" ProviderType="Int32" Scale="0" Size="7" SourceColumn="HASTAFECHA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="Original_HASTAFECHA" Precision="0" ProviderType="Date" Scale="0" Size="7" SourceColumn="HASTAFECHA" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDPROMOCION" DataSetColumn="IDPROMOCION" />
              <Mapping SourceColumn="DESCRIPCION" DataSetColumn="DESCRIPCION" />
              <Mapping SourceColumn="IDPRODUCTO" DataSetColumn="IDPRODUCTO" />
              <Mapping SourceColumn="IDTIPOPRODUCTO" DataSetColumn="IDTIPOPRODUCTO" />
              <Mapping SourceColumn="CANTIDADCOMPRAR" DataSetColumn="CANTIDADCOMPRAR" />
              <Mapping SourceColumn="UNIDADESOBSEQUIAR" DataSetColumn="UNIDADESOBSEQUIAR" />
              <Mapping SourceColumn="DESDEFECHA" DataSetColumn="DESDEFECHA" />
              <Mapping SourceColumn="HASTAFECHA" DataSetColumn="HASTAFECHA" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.FAC_PROMOCIONES" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdPromocion" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdPromocion" GeneratorSourceName="FillByIdPromocion" GetMethodModifier="Public" GetMethodName="GetDataByIdPromocion" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdPromocion" UserSourceName="FillByIdPromocion">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        IDPROMOCION, DESCRIPCION, IDPRODUCTO, IDTIPOPRODUCTO, CANTIDADCOMPRAR, UNIDADESOBSEQUIAR, DESDEFECHA, HASTAFECHA
FROM            FAC_PROMOCIONES
WHERE        (IDPROMOCION = :pIDPROMOCION)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="pIDPROMOCION" ColumnName="IDPROMOCION" DataSourceName="SAMUEL.FAC_PROMOCIONES" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":pIDPROMOCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDPROMOCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FAC_TABLADESCUENTOSTableAdapter" GeneratorDataComponentClassName="FAC_TABLADESCUENTOSTableAdapter" Name="FAC_TABLADESCUENTOS" UserDataComponentName="FAC_TABLADESCUENTOSTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.FAC_TABLADESCUENTOS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "SAMUEL"."FAC_TABLADESCUENTOS" WHERE (("IDDESCUENTO" = :Original_IDDESCUENTO) AND ((:IsNull_IDCANAL = 1 AND "IDCANAL" IS NULL) OR ("IDCANAL" = :Original_IDCANAL)) AND ((:IsNull_IDLISTA = 1 AND "IDLISTA" IS NULL) OR ("IDLISTA" = :Original_IDLISTA)) AND ((:IsNull_DESDEVALOR = 1 AND "DESDEVALOR" IS NULL) OR ("DESDEVALOR" = :Original_DESDEVALOR)) AND ((:IsNull_HASTAVALOR = 1 AND "HASTAVALOR" IS NULL) OR ("HASTAVALOR" = :Original_HASTAVALOR)) AND ((:IsNull_PORCENTAJEDTO = 1 AND "PORCENTAJEDTO" IS NULL) OR ("PORCENTAJEDTO" = :Original_PORCENTAJEDTO)) AND ((:IsNull_VALORDTO = 1 AND "VALORDTO" IS NULL) OR ("VALORDTO" = :Original_VALORDTO)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDDESCUENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDESCUENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDCANAL" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDCANAL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCANAL" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCANAL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDLISTA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDLISTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESDEVALOR" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="DESDEVALOR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_DESDEVALOR" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DESDEVALOR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_HASTAVALOR" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="HASTAVALOR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_HASTAVALOR" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="HASTAVALOR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PORCENTAJEDTO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="PORCENTAJEDTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_PORCENTAJEDTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PORCENTAJEDTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VALORDTO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VALORDTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORDTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORDTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "SAMUEL"."FAC_TABLADESCUENTOS" ("IDDESCUENTO", "IDCANAL", "IDLISTA", "DESDEVALOR", "HASTAVALOR", "PORCENTAJEDTO", "VALORDTO") VALUES (:IDDESCUENTO, :IDCANAL, :IDLISTA, :DESDEVALOR, :HASTAVALOR, :PORCENTAJEDTO, :VALORDTO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDDESCUENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDESCUENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCANAL" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCANAL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDLISTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="DESDEVALOR" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DESDEVALOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="HASTAVALOR" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="HASTAVALOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="PORCENTAJEDTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PORCENTAJEDTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORDTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORDTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDDESCUENTO, IDCANAL, IDLISTA, DESDEVALOR, HASTAVALOR, PORCENTAJEDTO, VALORDTO FROM SAMUEL.FAC_TABLADESCUENTOS</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "SAMUEL"."FAC_TABLADESCUENTOS" SET "IDDESCUENTO" = :IDDESCUENTO, "IDCANAL" = :IDCANAL, "IDLISTA" = :IDLISTA, "DESDEVALOR" = :DESDEVALOR, "HASTAVALOR" = :HASTAVALOR, "PORCENTAJEDTO" = :PORCENTAJEDTO, "VALORDTO" = :VALORDTO WHERE (("IDDESCUENTO" = :Original_IDDESCUENTO) AND ((:IsNull_IDCANAL = 1 AND "IDCANAL" IS NULL) OR ("IDCANAL" = :Original_IDCANAL)) AND ((:IsNull_IDLISTA = 1 AND "IDLISTA" IS NULL) OR ("IDLISTA" = :Original_IDLISTA)) AND ((:IsNull_DESDEVALOR = 1 AND "DESDEVALOR" IS NULL) OR ("DESDEVALOR" = :Original_DESDEVALOR)) AND ((:IsNull_HASTAVALOR = 1 AND "HASTAVALOR" IS NULL) OR ("HASTAVALOR" = :Original_HASTAVALOR)) AND ((:IsNull_PORCENTAJEDTO = 1 AND "PORCENTAJEDTO" IS NULL) OR ("PORCENTAJEDTO" = :Original_PORCENTAJEDTO)) AND ((:IsNull_VALORDTO = 1 AND "VALORDTO" IS NULL) OR ("VALORDTO" = :Original_VALORDTO)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDDESCUENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDESCUENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCANAL" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCANAL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDLISTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="DESDEVALOR" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DESDEVALOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="HASTAVALOR" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="HASTAVALOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="PORCENTAJEDTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PORCENTAJEDTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="VALORDTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORDTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDDESCUENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDESCUENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDCANAL" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDCANAL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCANAL" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCANAL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDLISTA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDLISTA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDLISTA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESDEVALOR" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="DESDEVALOR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_DESDEVALOR" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DESDEVALOR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_HASTAVALOR" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="HASTAVALOR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_HASTAVALOR" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="HASTAVALOR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PORCENTAJEDTO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="PORCENTAJEDTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_PORCENTAJEDTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PORCENTAJEDTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VALORDTO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="VALORDTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_VALORDTO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="VALORDTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDDESCUENTO" DataSetColumn="IDDESCUENTO" />
              <Mapping SourceColumn="IDCANAL" DataSetColumn="IDCANAL" />
              <Mapping SourceColumn="IDLISTA" DataSetColumn="IDLISTA" />
              <Mapping SourceColumn="DESDEVALOR" DataSetColumn="DESDEVALOR" />
              <Mapping SourceColumn="HASTAVALOR" DataSetColumn="HASTAVALOR" />
              <Mapping SourceColumn="PORCENTAJEDTO" DataSetColumn="PORCENTAJEDTO" />
              <Mapping SourceColumn="VALORDTO" DataSetColumn="VALORDTO" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.FAC_TABLADESCUENTOS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdDescuento" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdDescuento" GeneratorSourceName="FillByIdDescuento" GetMethodModifier="Public" GetMethodName="GetDataByIdDescuento" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdDescuento" UserSourceName="FillByIdDescuento">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        IDDESCUENTO, IDCANAL, IDLISTA, DESDEVALOR, HASTAVALOR, PORCENTAJEDTO, VALORDTO
FROM            FAC_TABLADESCUENTOS
WHERE        (IDDESCUENTO = :PIDDESCUENTO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDDESCUENTO" ColumnName="IDDESCUENTO" DataSourceName="SAMUEL.FAC_TABLADESCUENTOS" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PIDDESCUENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDDESCUENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FAC_PORCENTAJEBASETableAdapter" GeneratorDataComponentClassName="FAC_PORCENTAJEBASETableAdapter" Name="FAC_PORCENTAJEBASE" UserDataComponentName="FAC_PORCENTAJEBASETableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.FAC_PORCENTAJEBASE" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "SAMUEL"."FAC_PORCENTAJEBASE" WHERE (("IDPORCENTAJE" = :Original_IDPORCENTAJE) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)) AND ((:IsNull_PORCENTAJE = 1 AND "PORCENTAJE" IS NULL) OR ("PORCENTAJE" = :Original_PORCENTAJE)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPORCENTAJE" Precision="0" ProviderType="Varchar2" Scale="0" Size="3" SourceColumn="IDPORCENTAJE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PORCENTAJE" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="PORCENTAJE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_PORCENTAJE" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PORCENTAJE" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "SAMUEL"."FAC_PORCENTAJEBASE" ("IDPORCENTAJE", "DESCRIPCION", "PORCENTAJE") VALUES (:IDPORCENTAJE, :DESCRIPCION, :PORCENTAJE)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPORCENTAJE" Precision="0" ProviderType="Varchar2" Scale="0" Size="3" SourceColumn="IDPORCENTAJE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="PORCENTAJE" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PORCENTAJE" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDPORCENTAJE, DESCRIPCION, PORCENTAJE FROM SAMUEL.FAC_PORCENTAJEBASE</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "SAMUEL"."FAC_PORCENTAJEBASE" SET "IDPORCENTAJE" = :IDPORCENTAJE, "DESCRIPCION" = :DESCRIPCION, "PORCENTAJE" = :PORCENTAJE WHERE (("IDPORCENTAJE" = :Original_IDPORCENTAJE) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)) AND ((:IsNull_PORCENTAJE = 1 AND "PORCENTAJE" IS NULL) OR ("PORCENTAJE" = :Original_PORCENTAJE)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPORCENTAJE" Precision="0" ProviderType="Varchar2" Scale="0" Size="3" SourceColumn="IDPORCENTAJE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="PORCENTAJE" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PORCENTAJE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPORCENTAJE" Precision="0" ProviderType="Varchar2" Scale="0" Size="3" SourceColumn="IDPORCENTAJE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PORCENTAJE" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="PORCENTAJE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_PORCENTAJE" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PORCENTAJE" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDPORCENTAJE" DataSetColumn="IDPORCENTAJE" />
              <Mapping SourceColumn="DESCRIPCION" DataSetColumn="DESCRIPCION" />
              <Mapping SourceColumn="PORCENTAJE" DataSetColumn="PORCENTAJE" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsFacturacion" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="dsFacturacion" msprop:Generator_DataSetName="dsFacturacion" msprop:EnableTableAdapterManager="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="FAC_CANALES" msprop:Generator_UserTableName="FAC_CANALES" msprop:Generator_RowDeletedName="FAC_CANALESRowDeleted" msprop:Generator_RowChangedName="FAC_CANALESRowChanged" msprop:Generator_RowClassName="FAC_CANALESRow" msprop:Generator_RowChangingName="FAC_CANALESRowChanging" msprop:Generator_RowEvArgName="FAC_CANALESRowChangeEvent" msprop:Generator_RowEvHandlerName="FAC_CANALESRowChangeEventHandler" msprop:Generator_TableClassName="FAC_CANALESDataTable" msprop:Generator_TableVarName="tableFAC_CANALES" msprop:Generator_RowDeletingName="FAC_CANALESRowDeleting" msprop:Generator_TablePropName="FAC_CANALES">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDCANAL" msprop:Generator_UserColumnName="IDCANAL" msprop:Generator_ColumnPropNameInRow="IDCANAL" msprop:Generator_ColumnVarNameInTable="columnIDCANAL" msprop:Generator_ColumnPropNameInTable="IDCANALColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDLISTA" msprop:Generator_UserColumnName="IDLISTA" msprop:Generator_ColumnPropNameInRow="IDLISTA" msprop:Generator_ColumnVarNameInTable="columnIDLISTA" msprop:Generator_ColumnPropNameInTable="IDLISTAColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DESCRIPCION" msprop:Generator_UserColumnName="DESCRIPCION" msprop:Generator_ColumnPropNameInRow="DESCRIPCION" msprop:Generator_ColumnVarNameInTable="columnDESCRIPCION" msprop:Generator_ColumnPropNameInTable="DESCRIPCIONColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PORRENTA" msprop:Generator_UserColumnName="PORRENTA" msprop:Generator_ColumnPropNameInRow="PORRENTA" msprop:Generator_ColumnVarNameInTable="columnPORRENTA" msprop:Generator_ColumnPropNameInTable="PORRENTAColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="FAC_PROMOCIONES" msprop:Generator_UserTableName="FAC_PROMOCIONES" msprop:Generator_RowDeletedName="FAC_PROMOCIONESRowDeleted" msprop:Generator_RowChangedName="FAC_PROMOCIONESRowChanged" msprop:Generator_RowClassName="FAC_PROMOCIONESRow" msprop:Generator_RowChangingName="FAC_PROMOCIONESRowChanging" msprop:Generator_RowEvArgName="FAC_PROMOCIONESRowChangeEvent" msprop:Generator_RowEvHandlerName="FAC_PROMOCIONESRowChangeEventHandler" msprop:Generator_TableClassName="FAC_PROMOCIONESDataTable" msprop:Generator_TableVarName="tableFAC_PROMOCIONES" msprop:Generator_RowDeletingName="FAC_PROMOCIONESRowDeleting" msprop:Generator_TablePropName="FAC_PROMOCIONES">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDPROMOCION" msprop:Generator_UserColumnName="IDPROMOCION" msprop:Generator_ColumnPropNameInRow="IDPROMOCION" msprop:Generator_ColumnVarNameInTable="columnIDPROMOCION" msprop:Generator_ColumnPropNameInTable="IDPROMOCIONColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DESCRIPCION" msprop:Generator_UserColumnName="DESCRIPCION" msprop:Generator_ColumnPropNameInRow="DESCRIPCION" msprop:Generator_ColumnVarNameInTable="columnDESCRIPCION" msprop:Generator_ColumnPropNameInTable="DESCRIPCIONColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDPRODUCTO" msprop:Generator_UserColumnName="IDPRODUCTO" msprop:Generator_ColumnPropNameInRow="IDPRODUCTO" msprop:Generator_ColumnVarNameInTable="columnIDPRODUCTO" msprop:Generator_ColumnPropNameInTable="IDPRODUCTOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDTIPOPRODUCTO" msprop:Generator_UserColumnName="IDTIPOPRODUCTO" msprop:Generator_ColumnPropNameInRow="IDTIPOPRODUCTO" msprop:Generator_ColumnVarNameInTable="columnIDTIPOPRODUCTO" msprop:Generator_ColumnPropNameInTable="IDTIPOPRODUCTOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CANTIDADCOMPRAR" msprop:Generator_UserColumnName="CANTIDADCOMPRAR" msprop:Generator_ColumnPropNameInRow="CANTIDADCOMPRAR" msprop:Generator_ColumnVarNameInTable="columnCANTIDADCOMPRAR" msprop:Generator_ColumnPropNameInTable="CANTIDADCOMPRARColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="UNIDADESOBSEQUIAR" msprop:Generator_UserColumnName="UNIDADESOBSEQUIAR" msprop:Generator_ColumnPropNameInRow="UNIDADESOBSEQUIAR" msprop:Generator_ColumnVarNameInTable="columnUNIDADESOBSEQUIAR" msprop:Generator_ColumnPropNameInTable="UNIDADESOBSEQUIARColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="DESDEFECHA" msprop:Generator_UserColumnName="DESDEFECHA" msprop:Generator_ColumnPropNameInRow="DESDEFECHA" msprop:Generator_ColumnVarNameInTable="columnDESDEFECHA" msprop:Generator_ColumnPropNameInTable="DESDEFECHAColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="HASTAFECHA" msprop:Generator_UserColumnName="HASTAFECHA" msprop:Generator_ColumnPropNameInRow="HASTAFECHA" msprop:Generator_ColumnVarNameInTable="columnHASTAFECHA" msprop:Generator_ColumnPropNameInTable="HASTAFECHAColumn" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="FAC_TABLADESCUENTOS" msprop:Generator_UserTableName="FAC_TABLADESCUENTOS" msprop:Generator_RowDeletedName="FAC_TABLADESCUENTOSRowDeleted" msprop:Generator_RowChangedName="FAC_TABLADESCUENTOSRowChanged" msprop:Generator_RowClassName="FAC_TABLADESCUENTOSRow" msprop:Generator_RowChangingName="FAC_TABLADESCUENTOSRowChanging" msprop:Generator_RowEvArgName="FAC_TABLADESCUENTOSRowChangeEvent" msprop:Generator_RowEvHandlerName="FAC_TABLADESCUENTOSRowChangeEventHandler" msprop:Generator_TableClassName="FAC_TABLADESCUENTOSDataTable" msprop:Generator_TableVarName="tableFAC_TABLADESCUENTOS" msprop:Generator_RowDeletingName="FAC_TABLADESCUENTOSRowDeleting" msprop:Generator_TablePropName="FAC_TABLADESCUENTOS">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDDESCUENTO" msprop:Generator_UserColumnName="IDDESCUENTO" msprop:Generator_ColumnPropNameInRow="IDDESCUENTO" msprop:Generator_ColumnVarNameInTable="columnIDDESCUENTO" msprop:Generator_ColumnPropNameInTable="IDDESCUENTOColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDCANAL" msprop:Generator_UserColumnName="IDCANAL" msprop:Generator_ColumnPropNameInRow="IDCANAL" msprop:Generator_ColumnVarNameInTable="columnIDCANAL" msprop:Generator_ColumnPropNameInTable="IDCANALColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDLISTA" msprop:Generator_UserColumnName="IDLISTA" msprop:Generator_ColumnPropNameInRow="IDLISTA" msprop:Generator_ColumnVarNameInTable="columnIDLISTA" msprop:Generator_ColumnPropNameInTable="IDLISTAColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DESDEVALOR" msprop:Generator_UserColumnName="DESDEVALOR" msprop:Generator_ColumnPropNameInRow="DESDEVALOR" msprop:Generator_ColumnVarNameInTable="columnDESDEVALOR" msprop:Generator_ColumnPropNameInTable="DESDEVALORColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="HASTAVALOR" msprop:Generator_UserColumnName="HASTAVALOR" msprop:Generator_ColumnPropNameInRow="HASTAVALOR" msprop:Generator_ColumnVarNameInTable="columnHASTAVALOR" msprop:Generator_ColumnPropNameInTable="HASTAVALORColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="PORCENTAJEDTO" msprop:Generator_UserColumnName="PORCENTAJEDTO" msprop:Generator_ColumnPropNameInRow="PORCENTAJEDTO" msprop:Generator_ColumnVarNameInTable="columnPORCENTAJEDTO" msprop:Generator_ColumnPropNameInTable="PORCENTAJEDTOColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="VALORDTO" msprop:Generator_UserColumnName="VALORDTO" msprop:Generator_ColumnPropNameInRow="VALORDTO" msprop:Generator_ColumnVarNameInTable="columnVALORDTO" msprop:Generator_ColumnPropNameInTable="VALORDTOColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="FAC_PORCENTAJEBASE" msprop:Generator_UserTableName="FAC_PORCENTAJEBASE" msprop:Generator_RowDeletedName="FAC_PORCENTAJEBASERowDeleted" msprop:Generator_RowChangedName="FAC_PORCENTAJEBASERowChanged" msprop:Generator_RowClassName="FAC_PORCENTAJEBASERow" msprop:Generator_RowChangingName="FAC_PORCENTAJEBASERowChanging" msprop:Generator_RowEvArgName="FAC_PORCENTAJEBASERowChangeEvent" msprop:Generator_RowEvHandlerName="FAC_PORCENTAJEBASERowChangeEventHandler" msprop:Generator_TableClassName="FAC_PORCENTAJEBASEDataTable" msprop:Generator_TableVarName="tableFAC_PORCENTAJEBASE" msprop:Generator_RowDeletingName="FAC_PORCENTAJEBASERowDeleting" msprop:Generator_TablePropName="FAC_PORCENTAJEBASE">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDPORCENTAJE" msprop:Generator_UserColumnName="IDPORCENTAJE" msprop:Generator_ColumnPropNameInRow="IDPORCENTAJE" msprop:Generator_ColumnVarNameInTable="columnIDPORCENTAJE" msprop:Generator_ColumnPropNameInTable="IDPORCENTAJEColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DESCRIPCION" msprop:Generator_UserColumnName="DESCRIPCION" msprop:Generator_ColumnPropNameInRow="DESCRIPCION" msprop:Generator_ColumnVarNameInTable="columnDESCRIPCION" msprop:Generator_ColumnPropNameInTable="DESCRIPCIONColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PORCENTAJE" msprop:Generator_UserColumnName="PORCENTAJE" msprop:Generator_ColumnPropNameInRow="PORCENTAJE" msprop:Generator_ColumnVarNameInTable="columnPORCENTAJE" msprop:Generator_ColumnPropNameInTable="PORCENTAJEColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:FAC_CANALES" />
      <xs:field xpath="mstns:IDCANAL" />
    </xs:unique>
    <xs:unique name="FAC_PROMOCIONES_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:FAC_PROMOCIONES" />
      <xs:field xpath="mstns:IDPROMOCION" />
    </xs:unique>
    <xs:unique name="FAC_TABLADESCUENTOS_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:FAC_TABLADESCUENTOS" />
      <xs:field xpath="mstns:IDDESCUENTO" />
    </xs:unique>
    <xs:unique name="FAC_PORCENTAJEBASE_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:FAC_PORCENTAJEBASE" />
      <xs:field xpath="mstns:IDPORCENTAJE" />
    </xs:unique>
  </xs:element>
</xs:schema>